/*
 CREATE TABLE "base_gsj_rate" (
  "sequence_nbr" text(20) NOT NULL,
  "code" text(50),
  "name" text(255),
  "kind" text(10),
  "rate" real(16,6),
  "sort_no" integer(4),
  "remark" text(255),
  "tax_reform_documents_id" text(20),
  "tax_calculation_method" integer(4),
  "tax_paying_region" text(64),
  "rec_user_code" text(32),
  "rec_status" text(4),
  "rec_date" text(20),
  "extend1" text(64),
  "extend2" text(64),
  "extend3" text(64),
  "description" text(255),
  "agency_code" text(64),
  "product_code" text(64),
  PRIMARY KEY ("sequence_nbr")
);
  */

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct BaseGsjRate {
    pub sequence_nbr: String,
    pub code: Option<String>,
    pub name: Option<String>,
    pub kind: Option<String>,
    pub rate: Option<f64>,
    pub sort_no: Option<i32>,
    pub remark: Option<String>,
    pub tax_reform_documents_id: Option<String>,
    pub tax_calculation_method: Option<i32>,
    pub tax_paying_region: Option<String>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<String>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub description: Option<String>,
    pub agency_code: Option<String>,
    pub product_code: Option<String>,
}
crud!(BaseGsjRate {}, "base_gsj_rate");
